package com.yh.zz_hlj.db;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

/**
 * 创建数据库
 * 
 * @author imyar
 * 
 *         update:2014-01-12 updateor: fireant 内容：修改为全应用数据库
 * 
 */
public class DatabaseHelper extends SQLiteOpenHelper {

    public static final String YH_DATABASE_NAME = "yhzwscan.db";

    public static final String Work_TABLE_NAME = "yhzw_work_gx";

    public static final String CREATE_BASECATEGORY_TABLE = "create table "
            +Work_TABLE_NAME
            + " (Mid integer primary key autoincrement,FHBUser integer,"
            + " FHBUserName varchar(50), FBillNo varchar(50) unique)";

    public DatabaseHelper(Context context) {
        super(context, YH_DATABASE_NAME, null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(CREATE_BASECATEGORY_TABLE);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {}

}